1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's Shower Gel Bathroom Spy Camera HD 1080P DVR Motion Detection Remote Control On' at line 3
in:
[select count(p.products_id) as total FROM products p, products_description pd WHERE p.products_status = 1 AND p.products_id = pd.products_id AND pd.language_id = 1 and ( pd.products_name LIKE '%bathspycamera.com Men's Shower Gel Bathroom Spy Camera HD 1080P DVR Motion Detection Remote Control On/Off   Description: In so many kinds of hidden cameras%' OR p.products_model LIKE '%bathspycamera.com Men's Shower Gel Bathroom Spy Camera HD 1080P DVR Motion Detection Remote Control On/Off   Description: In so many kinds of hidden cameras%') ]